Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
EventID (PK) | A unique, automatically assigned identifier for the Event | ID_EV | Identity | integer | |
TypeCode | Identifies the category for the event. Examples Scheduled Event and Device Event | TY_EV | Code4 | char(4) | |
Name | The business name of the event. | NM_EV | Name | varchar(40) | |
Description | Describes the event. | DE_EV | DescriptionShort | varchar(255) | |
StatusCode | The current status code of the event -- e.g. active, pending, deferred, canceled, etc. | SC_EV | Code2Status | char(2) | |
ActualStartDateTimestamp | The actual start date and time for an event. | TS_EV_ACT_EF | AuditDateTime | datetime | |
ActualEndDateTimestamp | The actual time and date when the event terminates. | TS_EV_ACT_EP | AuditDateTime | datetime | |